Show All

Print row and column headings or labels on every page

Row headings are the row numbers to the left of the worksheet; column headings are the letters or numbers that appear at the top of the columns on a worksheet.

1. Click the worksheet.
2. On the File menu, click Page Setup, and then click the Sheet tab.
3. Do one of the following:

   Print row and column headings

   • Select the Row and column headings check box, and click Print.

   Print row and column labels on every page

   • To print column labels on every page, under Print titles in the Rows to repeat at top box, enter the rows that contain the column labels, and then click Print.

   • To print row labels on every page, under Print titles in the Columns to repeat at left box, enter the columns that contain the row labels, and then click Print.